SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Match2

Matching by two values at the same time in two columns Just like Match the ...

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

List of options (Frm87)

Show list of items with their description from "Settings" sheet Have that list ...

Frm87.zip

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...

ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...